﻿CREATE TABLE [dbo].[Employee_Post] (
    [id]             INT            IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [EId]            INT            NULL,
    [ENumber]        NVARCHAR (50)  NULL,
    [CompanyId]      INT            NULL,
    [DepartmentId]   NVARCHAR (50)  NULL,
    [RiZhiDate]      DATETIME       NULL,
    [ZhuanZhengDate] DATETIME       NULL,
    [PostId]         INT            NULL,
    [GradeId]        INT            NULL,
    [JianZhi]        NVARCHAR (200) NULL,
    [Rtx]            NVARCHAR (50)  NULL,
    [WageCardNo]     NVARCHAR (50)  NULL,
    [WageNumber]     NVARCHAR (50)  NULL,
    [UpTime]         DATETIME       CONSTRAINT [DF_Employee_Post_UpTime] DEFAULT (getdate()) NULL,
    CONSTRAINT [PK_Employee_Post] PRIMARY KEY CLUSTERED ([id] ASC)
);

